using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace ProjectManageSystemApi.DbEntity {

	/// <summary>
	/// 供应商信息表
	/// </summary>
	[JsonObject(MemberSerialization.OptIn), Table(Name = "supplier_info", DisableSyncStructure = true)]
	public partial class SupplierInfo {

		[JsonProperty, Column(Name = "id", IsPrimary = true, IsIdentity = true)]
		public int Id { get; set; }

		/// <summary>
		/// 供应商名称
		/// </summary>
		[JsonProperty, Column(Name = "supplier_name", StringLength = 100)]
		public string SupplierName { get; set; }

		/// <summary>
		/// 供应商地址
		/// </summary>
		[JsonProperty, Column(Name = "supplier_address", StringLength = 20)]
		public string SupplierAddress { get; set; }

		/// <summary>
		/// 联系人
		/// </summary>
		[JsonProperty, Column(Name = "contacts_user", StringLength = 20)]
		public string ContactsUser { get; set; }

		/// <summary>
		/// 联系人电话
		/// </summary>
		[JsonProperty, Column(Name = "contacts_phone", StringLength = 20)]
		public string ContactsPhone { get; set; }

		/// <summary>
		/// 状态(0正常1删除)
		/// </summary>
		[JsonProperty, Column(Name = "state", DbType = "tinyint(4)")]
		public sbyte State { get; set; }

		/// <summary>
		/// 创建时间
		/// </summary>
		[JsonProperty, Column(Name = "create_time")]
		public DateTime CreateTime { get; set; }

		/// <summary>
		/// 创建人
		/// </summary>
		[JsonProperty, Column(Name = "create_user", StringLength = 20)]
		public long CreateUser { get; set; }

		[Navigate(nameof(CreateUser))]
		public UserInfo UserInfo { get; set; }
	}

}
